<?php
//时间2.522ms
create procedure tianshl()   
begin   
declare num int;   
set num=1; 
while num <= 1000000 do    
insert into `role` (`name`,`pwd`) values (num,num);
set num=num+1;  
end while; 
end
//时间:27.880ms
create procedure tianshl()   
begin   
declare num int;   
set num=1; 
while num <= 1000000 do    
insert into `role` (`name`,`pwd`) values (num,num);
set num=num+1;  
end while; 
end
//时间:260.411ms
create procedure tianshl()   
begin   
declare num int;   
set num=1; 
while num <= 10000000 do    
insert into `role` (`name`,`pwd`) values (num,num);
set num=num+1;  
end while; 
end
?>